<?php
# ============================================================================
# 版权所有  Chilcoo.com，并保留所有权利。
# 网站地址: http://www.chilcoo.com/erphp
# ----------------------------------------------------------------------------
# 这不是一个自由软件！你不能通过任何方式破解本软件.
# 使用:不允许对程序代码以任何形式任何目的的再发布。
# ============================================================================
# $Author: Chilcoo Inc. *
# $Official website : www.chilcoo.com
# 
# 文件信息:
# File : /sell/default.php
# 分类列表页面

# 载入常用集
# 导入common
require_once (dirname(__FILE__).'/../../include/common.inc.php');
require_once (dirname(__FILE__).'/../../include/_manager/login.inc.php');
require_once (dirname(__FILE__).'/../../include/_manager/order.inc.php');
# 页面级别
$conf_web_page_level = 0;

class page_index extends page{
	function __construct(){
		global $config;
		$this->database = new db(config::conf_db_host,config::conf_db_user,
			config::conf_db_password,config::conf_db_name);
	}
	function ship_listview(){
		$lv = null;
		try{
			$sql = "SELECT shipId,dates,priceJp 
				FROM cs2_ship ORDER BY dates DESC LIMIT 0, 3;";
			$lv = $this->database->select($sql);
		}catch (Exception $e) {
			
		}
		return $lv;
	}
	function listview(){
		$lv = null;
		try{
			$sql = "SELECT SUM(cs2_sto.price)/COUNT(cs2_sto.price) AS price,
				COUNT(cs2_sto.price) AS numbers,SUM(cs2_sto.price) AS sumprice,
				cs2_sto.shipId,cs2_sto.prodId,name,model,cs2_sto.stoId,IFNULL(
				(SELECT COUNT(cs2_slist.prodId) FROM cs2_slist WHERE cs2_sto.prodId = cs2_slist.prodId),0) AS slistcnt
				FROM cs2_sto 
				LEFT JOIN (cs2_ship,cs2_prod) ON (cs2_sto.shipId = cs2_ship.shipId AND cs2_sto.prodId = cs2_prod.prodId)
				GROUP BY (cs2_sto.prodId);";
			$lv = $this->database->select($sql);
		}catch (Exception $e){
			
		}
		return $lv;
	}
	function ajax_callback(){
		global $config;
		# POST 数据
		$token = $_POST['token'];
		# 初始返回用 json
		$json = array("ref"=>"error");
		if($token == config::TOKEN_UPSELL_SELL){
			$sellId = $_POST['sellId'];
			$realfee = $_POST['realfee'];
			$transport = $_POST['transport'];
			$sendno = $_POST['sendno'];
			$adminId1 =$_POST['adminId1'];
			
			$sql = "UPDATE cs2_sell SET 
				realfee=".$realfee.",sendno='".$sendno."',adminId1=".$adminId1.",transport=".$transport."
			 	WHERE (sellId=". $sellId.");";
			try {
				$this->database->update($sql);
				$json = array("ref"=>"OK","id"=>$sellId);
			} catch (Exception $e) {
				$json = array("ref"=>"error,database.");
			}
		}
		return json_encode($json);
	}
}

$pg = new page_index();
# Session 和 POST 安全访问.
if($_SERVER['REQUEST_METHOD'] != 'POST'){
	$_SESSION[config::conf_session_id_token] = $config->web_page_period;
	# 订单时间划分。
	$config->smarty->assign('sell_dates', $_order->sell_dates());
	$config->smarty->assign('sell_nosend', $_order->sell_nosend());
	$config->smarty->assign('slist_nosend',$_order->slist_nosend());
	
	$config->smarty->assign('listview', $pg->listview());
	$config->smarty->assign('DATENOW',date("Y-m-d"));
	$config->smarty->assign('len', count($_order->sell_nosend()));
	# 加载页面
	$pg->render($config->temp_page_path.config::conf_web_template_extension);
}else{
	print_r($pg->ajax_callback());
}




?>